select n.idalumno, a1.nombre1,a1.apellido1,t.nombretaller,f.nombrefase,pf.pregunta,n.fallas,n.porcen,n.fechare from alumno as a1
left join alumnosxtaller as at on a1.idalumno = at.idalumno
left join taller as t on at.idtaller = t.idtaller
left join fases as f on t.idtaller = f.idtaller
left join preguntasxfase as pf on f.idfases = f.idfases
left join notas as n on f.idfases = n.idfases order by a1.nombre1